{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Help with Macros","Work Orders","Utility Owners and Parcels","Relo Schedule Phase 1","Relo Schedule Phase 2","Example Parcels","Example"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Help with Macros","index":0,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[[5,13,10,23]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"If the file has a red banner and says macros are disbaled then it is likely the location of the file saved is on your network and the network has all macros disabled, the work around would be to save as to your desktop."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trusted location"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"First go to file, options and go to trust center. Then click trust center settings…"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Then go to trusted locations. At the bottom you click Add new location…"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This will allow you to add a file location that excel will trust and the macros and everything will run properly."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As you can see, I have added my desktop and OneDrive. When I save to another location not in the trusted locations, and I save it to an untrusted location the document does not work properly."]

{"sheet":"Work Orders","index":1,"n_rows":9,"n_cols":20,"rows_kept":9,"cut":false,"hidden":false,"merged":[[6,0,8,0],[6,1,8,1],[6,2,8,2],[0,0,0,17],[1,3,1,12],[2,0,4,0],[2,1,4,1],[2,2,4,2]]}
["TIP No. X-XXXX Utility Priority Parcels"]
["Duke Work Order","UbO Sheet","Station Range",null,null,null,null,null,null,null,null,null,null,null,"Acquired","Total","% Complete"]
[1,"UO-2 - UO-8","10+00 - 100+00",2,5,6,12,13,14,15,16,17,18]
[null,null,null,19,23,24,25,26,27,28,29,30,31,null,26,27,{"$f":"O4/P4","v":0.96296296296296291},null,null,"Waiting to be recorded"]
[null,null,null,32,33,34,35,38,72,73,null,null,null,null,null,null,null,null,null,"Initial Contact"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"On Hold"]
[2,"UO-9 - UO-15","100+00 - 162+00",40,41,42,43,44,45,46,47,48,49,null,null,null,null,null,null,"Condemnation"]
[null,null,null,50,51,54,55,56,57,58,63,64,66,null,24,28,{"$f":"O8/P8","v":0.8571428571428571},null,null,"Filed"]
[null,null,null,67,68,69,70,71,74,75,77]

{"sheet":"Utility Owners and Parcels","index":2,"n_rows":110,"n_cols":32,"rows_kept":110,"cut":false,"hidden":false,"merged":[[14,0,15,3],[7,5,7,8]]}
["Legend",null,"Acquired",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acquired","Hidden"]
[null,null,"Waiting to be recorded",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waiting to be recorded"]
[null,null,"Initial Contact",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Initial Contact"]
[null,null,"On Hold",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"On Hold"]
[null,null,"Condemnation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condemnation"]
[null,null,"Filed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Filed"]
[null,null,null,null,null,"Replace \"Utility Owner\" with actual Utility Owner names"]
["Acquired","Total","% of Parcels Acquired","Acquired Date",null,"If Utility owner is on parcel select them from dropdown"]
[{"$f":"COUNTIF(F11:F110, \"Acquired\")+COUNTIF(F11:F110, \"Filed\")","v":0},{"$f":"COUNTIF(Table223[Status],\"*\")","v":0},{"$f":"IF(B9=0,\"\",A9/B9)","v":""}]
[null,null,null,null,null,"Status","Parcel #","Utility owner 1","Utility owner 2","Utility owner 3","Utility owner 4","Utility owner 5","Utility owner 6","Utility owner 7","Utility owner 8","Utility owner 9","Utility owner 10","Utility owner 11","Utility owner 12","Utility owner 13","Utility owner 14","Backflow Preventer"]
[null,"V1.3",null,null,null,null,"Parcel 001"]
[null,null,null,null,null,null,"Parcel 002"]
[null,null,null,null,null,null,"Parcel 003"]
[null,null,null,null,null,null,"Parcel 004"]
["To use buttons you must have the file saved to your trusted file location, instruction on help sheet",null,null,null,null,null,"Parcel 005"]
[null,null,null,null,null,null,"Parcel 006"]
[null,null,null,null,null,null,"Parcel 007"]
[null,null,null,null,null,null,"Parcel 008"]
[null,null,null,null,null,null,"Parcel 009"]
[null,null,null,null,null,null,"Parcel 010"]
[null,null,null,null,null,null,"Parcel 011"]
[null,null,null,null,null,null,"Parcel 012"]
[null,null,null,null,null,null,"Parcel 013"]
[null,null,null,null,null,null,"Parcel 014"]
[null,null,null,null,null,null,"Parcel 015"]
[null,null,null,null,null,null,"Parcel 016"]
[null,null,null,null,null,null,"Parcel 017"]
[null,null,null,null,null,null,"Parcel 018"]
[null,null,null,null,null,null,"Parcel 019"]
[null,null,null,null,null,null,"Parcel 020"]
[null,null,null,null,null,null,"Parcel 021"]
[null,null,null,null,null,null,"Parcel 022"]
[null,null,null,null,null,null,"Parcel 023"]
[null,null,null,null,null,null,"Parcel 024"]
[null,null,null,null,null,null,"Parcel 025"]
[null,null,null,null,null,null,"Parcel 026"]
[null,null,null,null,null,null,"Parcel 027"]
[null,null,null,null,null,null,"Parcel 028"]
[null,null,null,null,null,null,"Parcel 029"]
[null,null,null,null,null,null,"Parcel 030"]
[null,null,null,null,null,null,"Parcel 031"]
[null,null,null,null,null,null,"Parcel 032"]
[null,null,null,null,null,null,"Parcel 033"]
[null,null,null,null,null,null,"Parcel 034"]
[null,null,null,null,null,null,"Parcel 035"]
[null,null,null,null,null,null,"Parcel 036"]
[null,null,null,null,null,null,"Parcel 037"]
[null,null,null,null,null,null,"Parcel 038"]
[null,null,null,null,null,null,"Parcel 039"]
[null,null,null,null,null,null,"Parcel 040"]
[null,null,null,null,null,null,"Parcel 041"]
[null,null,null,null,null,null,"Parcel 042"]
[null,null,null,null,null,null,"Parcel 043"]
[null,null,null,null,null,null,"Parcel 044"]
[null,null,null,null,null,null,"Parcel 045"]
[null,null,null,null,null,null,"Parcel 046"]
[null,null,null,null,null,null,"Parcel 047"]
[null,null,null,null,null,null,"Parcel 048"]
[null,null,null,null,null,null,"Parcel 049"]
[null,null,null,null,null,null,"Parcel 050"]
[null,null,null,null,null,null,"Parcel 051"]
[null,null,null,null,null,null,"Parcel 052"]
[null,null,null,null,null,null,"Parcel 053"]
[null,null,null,null,null,null,"Parcel 054"]
[null,null,null,null,null,null,"Parcel 055"]
[null,null,null,null,null,null,"Parcel 056"]
[null,null,null,null,null,null,"Parcel 057"]
[null,null,null,null,null,null,"Parcel 058"]
[null,null,null,null,null,null,"Parcel 059"]
[null,null,null,null,null,null,"Parcel 060"]
[null,null,null,null,null,null,"Parcel 061"]
[null,null,null,null,null,null,"Parcel 062"]
[null,null,null,null,null,null,"Parcel 063"]
[null,null,null,null,null,null,"Parcel 064"]
[null,null,null,null,null,null,"Parcel 065"]
[null,null,null,null,null,null,"Parcel 066"]
[null,null,null,null,null,null,"Parcel 067"]
[null,null,null,null,null,null,"Parcel 068"]
[null,null,null,null,null,null,"Parcel 069"]
[null,null,null,null,null,null,"Parcel 070"]
[null,null,null,null,null,null,"Parcel 071"]
[null,null,null,null,null,null,"Parcel 072"]
[null,null,null,null,null,null,"Parcel 073"]
[null,null,null,null,null,null,"Parcel 074"]
[null,null,null,null,null,null,"Parcel 075"]
[null,null,null,null,null,null,"Parcel 076"]
[null,null,null,null,null,null,"Parcel 077"]
[null,null,null,null,null,null,"Parcel 078"]
[null,null,null,null,null,null,"Parcel 079"]
[null,null,null,null,null,null,"Parcel 080"]
[null,null,null,null,null,null,"Parcel 081"]
[null,null,null,null,null,null,"Parcel 082"]
[null,null,null,null,null,null,"Parcel 083"]
[null,null,null,null,null,null,"Parcel 084"]
[null,null,null,null,null,null,"Parcel 085"]
[null,null,null,null,null,null,"Parcel 086"]
[null,null,null,null,null,null,"Parcel 087"]
[null,null,null,null,null,null,"Parcel 088"]
[null,null,null,null,null,null,"Parcel 089"]
[null,null,null,null,null,null,"Parcel 090"]
[null,null,null,null,null,null,"Parcel 091"]
[null,null,null,null,null,null,"Parcel 092"]
[null,null,null,null,null,null,"Parcel 093"]
[null,null,null,null,null,null,"Parcel 094"]
[null,null,null,null,null,null,"Parcel 095"]
[null,null,null,null,null,null,"Parcel 096"]
[null,null,null,null,null,null,"Parcel 097"]
[null,null,null,null,null,null,"Parcel 098"]
[null,null,null,null,null,null,"Parcel 099"]
[null,null,null,null,null,null,"Parcel 100"]

{"sheet":"Relo Schedule Phase 1","index":3,"n_rows":48,"n_cols":57,"rows_kept":48,"cut":false,"hidden":false,"merged":[[2,6,2,7],[2,3,2,4],[2,9,2,10],[2,17,2,43],[0,9,0,10],[0,12,0,13],[1,12,1,13],[0,6,0,7],[1,8,1,9]]}
["V1.3",null,null,null,null,null,"Final PUE Due Date:",null,null,"PUE Approval Date:",null,null,"URA Approval Date:",null,null,{"$f":"DATEDIF(MIN(I3,O1), MAX(I3,O1), \"m\") * SIGN(O1 - I3)","v":{"$error":"#VALUE!"}},{"$f":"DATEDIF(MIN(I1,L1), MAX(I1,L1), \"m\") * SIGN(L1 - I1)","v":0}]
["Utility Coordinator shall verfiy all Utilty Owners are listed and included on the Relocation Schedule",null,null,null,null,null,null,null,"PUE Approval Date compared to PUE Due Date:",null,{"$f":"IF(L1=\"\",\"\",ABS(Q1))","v":""},{"$f":"IF(L1=\"\",\"\",IF(Q1<0,\"Months Ahead Schedule\",IF(Q1=0,\"On Schedule\",\"Months Behind Schedule\")))","v":""},"URA Approval Date compared to URBOB Start Date:",null,{"$f":"IF(O1=\"\",\"\",ABS(P1))","v":""},{"$f":"IF(L1=\"\",\"\",IF(P1<0,\"Months Ahead Schedule\",IF(P1=0,\"On Schedule\",\"Months Behind Schedule\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hidden cell do not edit",null,null,null,null,null,null,null,null,null,"Hidden","Hidden","Hidden"]
["Enter LET Date:",null,null,"Utility Priority Parcels Aquired Date:",null,{"$f":"IF('Utility Owners and Parcels'!D9=\"\",\"\",'Utility Owners and Parcels'!D9)","v":""},"URBOB Projected Start Date: ",null,{"$f":"IF(F3=\"\",\"\",EDATE(F3,2))","v":""},"URBOC Completed Date:",null,{"$f":"IF(F3=\"\",\"\",MAX(IF(P6:P50<>\"\", P6:P50, O6:O50)))","v":""},"Moratorium Date Range","Start Date:",null,"Finish Date:",null,{"$f":"IF(TEXT($L$3,\"mmyyyy\")=TEXT($C$3,\"mmyyyy\"),\"The project is letting same month as projected relocation finish\",IF(MATCH(\"URBOC\",$R5:$AR5,0)<MATCH(\"LET\",$R5:$AR5,0),\"The relocation is projected to finish before the LET Date\", \"Relocation is projected to be unfinished by the Let Date\"))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(AS4), MONTH(AS4), 1)","v":"1900-01-01"},null,null,null,null,null,null,null,null,"URA","Approved","U&O","Yes"]
["Utility Owner","Utility Priority Parcels","Agreement Package Comments","Package Reviewer","Package Date Recieved From Owner","Date sent to Central for Review/Approval","Package Type","Package Status","Approval Date","Relocation Duration (In calendar days)","Utility Owner Confirmed Duration ","Utility Owner Confirmation Date","Notification/Scheduling","Utility Owner Actual Start Date","Utility Owner Projected Finish Date","Utility Owner Actual Finish Date","Utility Owner (Relocation) Comments",{"$f":"AS3","v":"1900-01-01"},{"$f":"EDATE(R4,1)","v":"1900-02-01"},{"$f":"EDATE(S4,1)","v":"1900-03-01"},"1900-04-01","1900-05-01","1900-06-01","1900-07-01","1900-08-01","1900-09-01","1900-10-01","1900-11-01","1900-12-01","1901-01-01","1901-02-01","1901-03-01","1901-04-01","1901-05-01","1901-06-01","1901-07-01","1901-08-01","1901-09-01","1901-10-01","1901-11-01","1901-12-01","1902-01-01",{"$f":"EDATE(AP4,1)","v":"1902-02-01"},{"$f":"EDATE(AQ4,1)","v":"1902-03-01"},{"$f":"MIN(N6:N49)","v":"00:00:00"},null,null,null,null,null,null,null,null,"U&O","In Progress"]
["UBO- Aerial/ List in order of relocation (Joint use poles)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Automated",null,null,{"$f":"IF(AND(DATE(YEAR(R4),MONTH(R4),1)>=DATE(YEAR($O$3),MONTH($O$3),1),\nDATE(YEAR(R4),MONTH(R4),1)<=DATE(YEAR($Q$3),MONTH($Q$3),1)),\n\"Morato.\",IF(AND(TEXT($L$3,\"mmyyyy\")=TEXT($C$3,\"mmyyyy\"),(TEXT(R4,\"mmyyyy\")=TEXT($C$3,\"mmyyyy\"))),\"LET & URBOC\",IF(TEXT($C$3,\"mmyyyy\")=TEXT(R$4,\"mmyyyy\"),\"LET\",IF(TEXT(MIN($N$6:$N$48),\"mmyyyy\")=TEXT(R$4,\"mmyyyy\"),\"URBOB\",IF(TEXT($L$3,\"mmyyyy\")=TEXT(R$4,\"mmyyyy\"),\"URBOC\",\"\")))))","v":"Morato."},{"$f":"IF(AND(DATE(YEAR(S4),MONTH(S4),1)>=DATE(YEAR($O$3),MONTH($O$3),1),\nDATE(YEAR(S4),MONTH(S4),1)<=DATE(YEAR($Q$3),MONTH($Q$3),1)),\n\"Morato.\",IF(AND(TEXT($L$3,\"mmyyyy\")=TEXT($C$3,\"mmyyyy\"),(TEXT(S4,\"mmyyyy\")=TEXT($C$3,\"mmyyyy\"))),\"LET & URBOC\",IF(TEXT($C$3,\"mmyyyy\")=TEXT(S$4,\"mmyyyy\"),\"LET\",IF(TEXT(MIN($N$6:$N$48),\"mmyyyy\")=TEXT(S$4,\"mmyyyy\"),\"URBOB\",IF(TEXT($L$3,\"mmyyyy\")=TEXT(S$4,\"mmyyyy\"),\"URBOC\",\"\")))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,null,null,null,null,"UCA","Revisions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N6=\"\",\"\",N6+J6)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(N6), MONTH(N6), 1)","v":"1900-01-01"},null,null,null,null,null,null,null,null,16.100000000000001,"Re-Submitted"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N7=\"\",\"\",N7+J7)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(N7), MONTH(N7), 1)","v":"1900-01-01"},null,null,null,null,null,null,null,null,"UPEA","Not Started"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N8=\"\",\"\",N8+J8)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01",null,null,null,null,null,null,null,null,null,"No Conflict"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N9=\"\",\"\",N9+J9)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N10=\"\",\"\",N10+J10)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N11=\"\",\"\",N11+J11)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N19=\"\",\"\",N19+J19)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
["UBO- Underground",null,null,null,null,null,null,null,null,null," ",null,null,null,{"$f":"IF(N21=\"\",\"\",N21+J21)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(N23), MONTH(N23), 1)","v":"1900-01-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
["UC",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(N42), MONTH(N42), 1)","v":"1900-01-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]

{"sheet":"Relo Schedule Phase 2","index":4,"n_rows":48,"n_cols":57,"rows_kept":48,"cut":false,"hidden":false,"merged":[[2,3,2,4],[2,6,2,7],[2,9,2,10],[2,17,2,43],[0,6,0,7],[0,9,0,10],[0,12,0,13],[1,8,1,9],[1,12,1,13]]}
["V1.3",null,null,null,null,null,"Final PUE Due Date:",null,null,"PUE Approval Date:",null,null,"URA Approval Date:",null,null,{"$f":"DATEDIF(MIN(I3,O1), MAX(I3,O1), \"m\") * SIGN(O1 - I3)","v":{"$error":"#VALUE!"}},{"$f":"DATEDIF(MIN(I1,L1), MAX(I1,L1), \"m\") * SIGN(L1 - I1)","v":0}]
["Utility Coordinator shall verfiy all Utilty Owners are listed and included on the Relocation Schedule",null,null,null,null,null,null,null,"PUE Approval Date compared to PUE Due Date:",null,{"$f":"IF(L1=\"\",\"\",ABS(Q1))","v":""},{"$f":"IF(L1=\"\",\"\",IF(Q1<0,\"Months Ahead Schedule\",IF(Q1=0,\"On Schedule\",\"Months Behind Schedule\")))","v":""},"URA Approval Date compared to URBOB Start Date:",null,{"$f":"IF(O1=\"\",\"\",ABS(P1))","v":""},{"$f":"IF(L1=\"\",\"\",IF(P1<0,\"Months Ahead Schedule\",IF(P1=0,\"On Schedule\",\"Months Behind Schedule\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hidden cell do not edit",null,null,null,null,null,null,null,null,null,"Hidden","Hidden","Hidden"]
["Enter LET Date:",null,"2027-07-20","Utility Priority Parcels Aquired Date:",null,{"$f":"IF('Utility Owners and Parcels'!D9=\"\",\"\",'Utility Owners and Parcels'!D9)","v":""},"URBOB Projected Start Date: ",null,{"$f":"IF(F3=\"\",\"\",EDATE(F3,2))","v":""},"URBOC Completed Date:",null,{"$f":"IF(F3=\"\",\"\",MAX(IF(P6:P50<>\"\", P6:P50, O6:O50)))","v":""},"Moratorium Date Range","Start Date:",null,"Finish Date:",null,{"$f":"IF(TEXT($L$3,\"mmyyyy\")=TEXT($C$3,\"mmyyyy\"),\"The project is letting same month as projected relocation finish\",IF(MATCH(\"URBOC\",$R5:$AR5,0)<MATCH(\"LET\",$R5:$AR5,0),\"The relocation is projected to finish before the LET Date\", \"Relocation is projected to be unfinished by the Let Date\"))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(AS4), MONTH(AS4), 1)","v":"1900-01-01"},null,null,null,null,null,null,null,null,"URA","Approved","U&O","Yes"]
["Utility Owner","Utility Priority Parcels","Agreement Package Comments","Package Reviewer","Package Date Recieved From Owner","Date sent to Central for Review/Approval","Package Type","Package Status","Approval Date","Relocation Duration (In calendar days)","Utility Owner Confirmed Duration ","Utility Owner Confirmation Date","Notification/Scheduling","Utility Owner Actual Start Date","Utility Owner Projected Finish Date","Utility Owner Actual Finish Date","Utility Owner (Relocation) Comments",{"$f":"AS3","v":"1900-01-01"},{"$f":"EDATE(R4,1)","v":"1900-02-01"},{"$f":"EDATE(S4,1)","v":"1900-03-01"},"1900-04-01","1900-05-01","1900-06-01","1900-07-01","1900-08-01","1900-09-01","1900-10-01","1900-11-01","1900-12-01","1901-01-01","1901-02-01","1901-03-01","1901-04-01","1901-05-01","1901-06-01","1901-07-01","1901-08-01","1901-09-01","1901-10-01","1901-11-01","1901-12-01","1902-01-01",{"$f":"EDATE(AP4,1)","v":"1902-02-01"},{"$f":"EDATE(AQ4,1)","v":"1902-03-01"},{"$f":"MIN(N6:N49)","v":"00:00:00"},null,null,null,null,null,null,null,null,"U&O","In Progress"]
["UBO- Aerial/ List in order of relocation (Joint use poles)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Automated",null,null,{"$f":"IF(AND(DATE(YEAR(R4),MONTH(R4),1)>=DATE(YEAR($O$3),MONTH($O$3),1),\nDATE(YEAR(R4),MONTH(R4),1)<=DATE(YEAR($Q$3),MONTH($Q$3),1)),\n\"Morato.\",IF(AND(TEXT($L$3,\"mmyyyy\")=TEXT($C$3,\"mmyyyy\"),(TEXT(R4,\"mmyyyy\")=TEXT($C$3,\"mmyyyy\"))),\"LET & URBOC\",IF(TEXT($C$3,\"mmyyyy\")=TEXT(R$4,\"mmyyyy\"),\"LET\",IF(TEXT(MIN($N$6:$N$48),\"mmyyyy\")=TEXT(R$4,\"mmyyyy\"),\"URBOB\",IF(TEXT($L$3,\"mmyyyy\")=TEXT(R$4,\"mmyyyy\"),\"URBOC\",\"\")))))","v":"Morato."},{"$f":"IF(AND(DATE(YEAR(S4),MONTH(S4),1)>=DATE(YEAR($O$3),MONTH($O$3),1),\nDATE(YEAR(S4),MONTH(S4),1)<=DATE(YEAR($Q$3),MONTH($Q$3),1)),\n\"Morato.\",IF(AND(TEXT($L$3,\"mmyyyy\")=TEXT($C$3,\"mmyyyy\"),(TEXT(S4,\"mmyyyy\")=TEXT($C$3,\"mmyyyy\"))),\"LET & URBOC\",IF(TEXT($C$3,\"mmyyyy\")=TEXT(S$4,\"mmyyyy\"),\"LET\",IF(TEXT(MIN($N$6:$N$48),\"mmyyyy\")=TEXT(S$4,\"mmyyyy\"),\"URBOB\",IF(TEXT($L$3,\"mmyyyy\")=TEXT(S$4,\"mmyyyy\"),\"URBOC\",\"\")))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","",null,null,null,null,null,null,null,null,null,"UCA","Revisions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N6=\"\",\"\",N6+J6)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(N6), MONTH(N6), 1)","v":"1900-01-01"},null,null,null,null,null,null,null,null,16.100000000000001,"Re-Submitted"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(N7), MONTH(N7), 1)","v":"1900-01-01"},null,null,null,null,null,null,null,null,"UPEA","Not Started"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null," ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
["UBO- Underground",null,null,null,null,null,null,null,null,null," ",null,null,null,{"$f":"IF(N21=\"\",\"\",N21+J21)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N22=\"\",\"\",N22+J22)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N23=\"\",\"\",N23+J23)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(N23), MONTH(N23), 1)","v":"1900-01-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null," ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null," ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null," ",null,null,null,{"$f":"IF(N28=\"\",\"\",N28+J28)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(N28), MONTH(N28), 1)","v":"1900-01-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N29=\"\",\"\",N29+J29)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(N29), MONTH(N29), 1)","v":"1900-01-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
["UC",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(N42), MONTH(N42), 1)","v":"1900-01-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]

{"sheet":"Example Parcels","index":5,"n_rows":110,"n_cols":32,"rows_kept":110,"cut":false,"hidden":false,"merged":[[7,5,7,8],[14,0,14,3]]}
["Legend",null,"Acquired",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acquired","Hidden"]
[null,null,"Waiting to be recorded",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waiting to be recorded"]
[null,null,"Initial Contact",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Initial Contact"]
[null,null,"On Hold",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"On Hold"]
[null,null,"Condemnation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Condemnation"]
[null,null,"Filed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Filed"]
[null,null,null,null,null,"Replace \"Utility Owner \" with actual Utility Owner names"]
["Acquired","Total","% of Parcels Acquired","Acquired Date",null,"If Utility owner is on parcel select them from dropdown"]
[{"$f":"COUNTIF(F11:F110, \"Acquired\")+COUNTIF(F11:F110, \"Filed\")","v":10},{"$f":"COUNTIF(Table2234[Status],\"*\")","v":10},{"$f":"IF(B9=0,\"\",A9/B9)","v":1},"2026-03-01"]
[null,null,null,null,null,"Status","Parcel #","Energy United","Duke Energy","Spectrum","Windstream","Electricities","AT&T","PNG","Segra","Charlotte water","Victory Comm","Lumen","MCNC","Utility owner 13","Utility owner 14","Backflow Preventer"]
[null,"EXAMPLE",null,null,null,"Acquired","Parcel 001",null,null,null,null,null,"AT&T","PNG"]
[null,null,null,null,null,"Acquired","Parcel 002","Energy United",null,null,null,"Electricities",null,null,null,null,null,"Lumen"]
[null,"V1.3",null,null,null,"Acquired","Parcel 003",null,"Duke Energy",null,null,null,"AT&T",null,null,null,"Victory Comm",null,"MCNC"]
[null,null,null,null,null,"Acquired","Parcel 004",null,null,null,"Windstream",null,null,null,null,"Charlotte water"]
["To use buttons you must have the file saved to your trusted file location, instruction on help sheet",null,null,null,null,"Acquired","Parcel 005",null,"Duke Energy",null,null,null,null,null,"Segra",null,null,"Lumen"]
[null,null,null,null,null,"Acquired","Parcel 006",null,null,null,null,null,null,null,"Segra",null,null,null,"MCNC"]
[null,null,null,null,null,"Acquired","Parcel 007",null,null,null,"Windstream"]
[null,null,null,null,null,"Acquired","Parcel 008",null,null,"Spectrum",null,null,null,null,null,null,null,null,null,null,null,"Backflow Preventer"]
[null,null,null,null,null,"Acquired","Parcel 009",null,null,null,null,null,"AT&T",null,null,null,"Victory Comm"]
[null,null,null,null,null,"Acquired","Parcel 010",null,"Duke Energy"]
[null,null,null,null,null,null,"Parcel 011"]
[null,null,null,null,null,null,"Parcel 012"]
[null,null,null,null,null,null,"Parcel 013"]
[null,null,null,null,null,null,"Parcel 014"]
[null,null,null,null,null,null,"Parcel 015"]
[null,null,null,null,null,null,"Parcel 016"]
[null,null,null,null,null,null,"Parcel 017"]
[null,null,null,null,null,null,"Parcel 018"]
[null,null,null,null,null,null,"Parcel 019"]
[null,null,null,null,null,null,"Parcel 020"]
[null,null,null,null,null,null,"Parcel 021"]
[null,null,null,null,null,null,"Parcel 022"]
[null,null,null,null,null,null,"Parcel 023"]
[null,null,null,null,null,null,"Parcel 024"]
[null,null,null,null,null,null,"Parcel 025"]
[null,null,null,null,null,null,"Parcel 026"]
[null,null,null,null,null,null,"Parcel 027"]
[null,null,null,null,null,null,"Parcel 028"]
[null,null,null,null,null,null,"Parcel 029"]
[null,null,null,null,null,null,"Parcel 030"]
[null,null,null,null,null,null,"Parcel 031"]
[null,null,null,null,null,null,"Parcel 032"]
[null,null,null,null,null,null,"Parcel 033"]
[null,null,null,null,null,null,"Parcel 034"]
[null,null,null,null,null,null,"Parcel 035"]
[null,null,null,null,null,null,"Parcel 036"]
[null,null,null,null,null,null,"Parcel 037"]
[null,null,null,null,null,null,"Parcel 038"]
[null,null,null,null,null,null,"Parcel 039"]
[null,null,null,null,null,null,"Parcel 040"]
[null,null,null,null,null,null,"Parcel 041"]
[null,null,null,null,null,null,"Parcel 042"]
[null,null,null,null,null,null,"Parcel 043"]
[null,null,null,null,null,null,"Parcel 044"]
[null,null,null,null,null,null,"Parcel 045"]
[null,null,null,null,null,null,"Parcel 046"]
[null,null,null,null,null,null,"Parcel 047"]
[null,null,null,null,null,null,"Parcel 048"]
[null,null,null,null,null,null,"Parcel 049"]
[null,null,null,null,null,null,"Parcel 050"]
[null,null,null,null,null,null,"Parcel 051"]
[null,null,null,null,null,null,"Parcel 052"]
[null,null,null,null,null,null,"Parcel 053"]
[null,null,null,null,null,null,"Parcel 054"]
[null,null,null,null,null,null,"Parcel 055"]
[null,null,null,null,null,null,"Parcel 056"]
[null,null,null,null,null,null,"Parcel 057"]
[null,null,null,null,null,null,"Parcel 058"]
[null,null,null,null,null,null,"Parcel 059"]
[null,null,null,null,null,null,"Parcel 060"]
[null,null,null,null,null,null,"Parcel 061"]
[null,null,null,null,null,null,"Parcel 062"]
[null,null,null,null,null,null,"Parcel 063"]
[null,null,null,null,null,null,"Parcel 064"]
[null,null,null,null,null,null,"Parcel 065"]
[null,null,null,null,null,null,"Parcel 066"]
[null,null,null,null,null,null,"Parcel 067"]
[null,null,null,null,null,null,"Parcel 068"]
[null,null,null,null,null,null,"Parcel 069"]
[null,null,null,null,null,null,"Parcel 070"]
[null,null,null,null,null,null,"Parcel 071"]
[null,null,null,null,null,null,"Parcel 072"]
[null,null,null,null,null,null,"Parcel 073"]
[null,null,null,null,null,null,"Parcel 074"]
[null,null,null,null,null,null,"Parcel 075"]
[null,null,null,null,null,null,"Parcel 076"]
[null,null,null,null,null,null,"Parcel 077"]
[null,null,null,null,null,null,"Parcel 078"]
[null,null,null,null,null,null,"Parcel 079"]
[null,null,null,null,null,null,"Parcel 080"]
[null,null,null,null,null,null,"Parcel 081"]
[null,null,null,null,null,null,"Parcel 082"]
[null,null,null,null,null,null,"Parcel 083"]
[null,null,null,null,null,null,"Parcel 084"]
[null,null,null,null,null,null,"Parcel 085"]
[null,null,null,null,null,null,"Parcel 086"]
[null,null,null,null,null,null,"Parcel 087"]
[null,null,null,null,null,null,"Parcel 088"]
[null,null,null,null,null,null,"Parcel 089"]
[null,null,null,null,null,null,"Parcel 090"]
[null,null,null,null,null,null,"Parcel 091"]
[null,null,null,null,null,null,"Parcel 092"]
[null,null,null,null,null,null,"Parcel 093"]
[null,null,null,null,null,null,"Parcel 094"]
[null,null,null,null,null,null,"Parcel 095"]
[null,null,null,null,null,null,"Parcel 096"]
[null,null,null,null,null,null,"Parcel 097"]
[null,null,null,null,null,null,"Parcel 098"]
[null,null,null,null,null,null,"Parcel 099"]
[null,null,null,null,null,null,"Parcel 100"]

{"sheet":"Example","index":6,"n_rows":50,"n_cols":57,"rows_kept":50,"cut":false,"hidden":false,"merged":[[2,3,2,4],[2,6,2,7],[2,9,2,10],[2,17,2,43],[0,6,0,7],[0,9,0,10],[0,12,0,13],[1,8,1,9],[1,12,1,13]]}
["V1.3",null,null,null,null,null,"Final PUE Due Date:",null,"2026-02-01","PUE Approval Date:",null,"2026-04-01","URA Approval Date:",null,"2026-03-01",{"$f":"DATEDIF(MIN(I3,O1), MAX(I3,O1), \"m\") * SIGN(O1 - I3)","v":-2},{"$f":"DATEDIF(MIN(I1,L1), MAX(I1,L1), \"m\") * SIGN(L1 - I1)","v":2}]
["Utility Coordinator shall verfiy all Utilty Owners are listed and included on the Relocation Schedule",null,null,null,null,null,null,null,"PUE Approval Date compared to PUE Due Date:",null,{"$f":"IF(L1=\"\",\"\",ABS(Q1))","v":2},{"$f":"IF(L1=\"\",\"\",IF(Q1<0,\"Months Ahead Schedule\",IF(Q1=0,\"On Schedule\",\"Months Behind Schedule\")))","v":"Months Behind Schedule"},"URA Approval Date compared to URBOB Start Date:",null,{"$f":"IF(O1=\"\",\"\",ABS(P1))","v":2},{"$f":"IF(L1=\"\",\"\",IF(P1<0,\"Months Ahead Schedule\",IF(P1=0,\"On Schedule\",\"Months Behind Schedule\")))","v":"Months Ahead Schedule"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hidden cell do not edit",null,null,null,null,null,null,null,null,null,"Hidden","Hidden","Hidden"]
["Enter LET Date:",null,"2027-10-20","Utility Priority Parcels Aquired Date:",null,{"$f":"'Example Parcels'!D9","v":"2026-03-01"},"URBOB Projected Start Date: ",null,{"$f":"EDATE(F3,2)","v":"2026-05-01"},"URBOC Completed Date:",null,{"$f":"IF(F3=\"\",\"\",MAX(IF(P6:P50<>\"\", P6:P50, O6:O50)))","v":"2027-06-29"},"Moratorium Date Range","Start Date:","2027-02-05","Finish Date:","2027-04-01",{"$f":"IF(TEXT($L$3,\"mmyyyy\")=TEXT($C$3,\"mmyyyy\"),\"The project is letting same month as projected relocation finish\",IF(MATCH(\"URBOC\",$R5:$AR5,0)<MATCH(\"LET\",$R5:$AR5,0),\"The relocation is projected to finish before the LET Date\", \"Relocation is projected to be unfinished by the Let Date\"))","v":"The relocation is projected to finish before the LET Date"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(AS4), MONTH(AS4), 1)","v":"2026-05-01"},null,null,null,null,null,null,null,null,"URA","Approved","U&O","Yes"]
["Utility Owner","Utility Priority Parcels","Agreement Package Comments","NCDOT Package Reviewer","Package Date Recieved From Owner","Date sent to Central for Review/Approval","Package Type","Package Status","Approval Date","Relocation Duration (In calendar days)","Utility Owner Confirmed Duration ","Utility Owner Confirmation Date","Notification/Scheduling","Utility Owner Actual Start Date","Utility Owner Projected Finish Date","Utility Owner Actual Finish Date","Utility Owner (Relocation) Comments",{"$f":"AS3","v":"2026-05-01"},{"$f":"EDATE(R4,1)","v":"2026-06-01"},{"$f":"EDATE(S4,1)","v":"2026-07-01"},"2026-08-01","2026-09-01","2026-10-01","2026-11-01","2026-12-01","2027-01-01","2027-02-01","2027-03-01","2027-04-01","2027-05-01","2027-06-01","2027-07-01","2027-08-01","2027-09-01","2027-10-01","2027-11-01","2027-12-01","2028-01-01","2028-02-01","2028-03-01","2028-04-01","2028-05-01",{"$f":"EDATE(AP4,1)","v":"2028-06-01"},{"$f":"EDATE(AQ4,1)","v":"2028-07-01"},{"$f":"MIN(N6:N51)","v":"2026-05-01"},null,null,null,null,null,null,null,null,"U&O","In Progress"]
["UBO- Aerial/ List in order of relocation (Joint use poles)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Automated",null,null,{"$f":"IF(AND(DATE(YEAR(R4),MONTH(R4),1)>=DATE(YEAR($O$3),MONTH($O$3),1),\nDATE(YEAR(R4),MONTH(R4),1)<=DATE(YEAR($Q$3),MONTH($Q$3),1)),\n\"Morato.\",IF(AND(TEXT($L$3,\"mmyyyy\")=TEXT($C$3,\"mmyyyy\"),(TEXT(R4,\"mmyyyy\")=TEXT($C$3,\"mmyyyy\"))),\"LET & URBOC\",IF(TEXT($C$3,\"mmyyyy\")=TEXT(R$4,\"mmyyyy\"),\"LET\",IF(TEXT(MIN($N$6:$N$50),\"mmyyyy\")=TEXT(R$4,\"mmyyyy\"),\"URBOB\",IF(TEXT($L$3,\"mmyyyy\")=TEXT(R$4,\"mmyyyy\"),\"URBOC\",\"\")))))","v":"URBOB"},{"$f":"IF(AND(DATE(YEAR(S4),MONTH(S4),1)>=DATE(YEAR($O$3),MONTH($O$3),1),\nDATE(YEAR(S4),MONTH(S4),1)<=DATE(YEAR($Q$3),MONTH($Q$3),1)),\n\"Morato.\",IF(AND(TEXT($L$3,\"mmyyyy\")=TEXT($C$3,\"mmyyyy\"),(TEXT(S4,\"mmyyyy\")=TEXT($C$3,\"mmyyyy\"))),\"LET & URBOC\",IF(TEXT($C$3,\"mmyyyy\")=TEXT(S$4,\"mmyyyy\"),\"LET\",IF(TEXT(MIN($N$6:$N$50),\"mmyyyy\")=TEXT(S$4,\"mmyyyy\"),\"URBOB\",IF(TEXT($L$3,\"mmyyyy\")=TEXT(S$4,\"mmyyyy\"),\"URBOC\",\"\")))))","v":""},"","","","","","","","Morato.","Morato.","Morato.","","URBOC","","","","LET","","","","","","","","","",null,null,null,null,null,null,null,null,null,"UCA","Revisions"]
["Energy United",null,"March 19 2026, put a request for an updated survey. Additional pole information. We received updated survey, March 27, 2026. Sent update to energy united March 30, 2026.","Dayton Martin","2026-01-16","2026-02-01","URA","In Progress",null,120,"Yes","2026-03-01",null,"2026-05-01",{"$f":"IF(N6=\"\",\"\",N6+J6)","v":"2026-08-29"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(N6), MONTH(N6), 1)","v":"2026-05-01"},null,null,null,null,null,null,null,null,16.100000000000001,"Re-Submitted"]
["Electricities",null,null,"Dayton Martin","2026-01-20","2026-02-16",16.100000000000001,"Approved",null,60,"Yes","2026-03-05",null,"2026-06-01","2026-07-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(N7), MONTH(N7), 1)","v":"2026-06-01"},null,null,null,null,null,null,null,null,"UPEA","Not Started"]
["Duke Energy",null,null,"Dayton Martin","2026-01-17","2026-03-01","URA","Approved",null,90,"Yes","2026-03-02","30 days prior To Energy  United complete","2026-08-01","2026-10-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-08-01"]
["Spectrum",null,"The design was not on NCDOT plans, it was sent back to spectrum. Feb. 23 2026","Dayton Martin","2026-01-18","2026-02-10",16.100000000000001,"Re-Submitted",null,150,"Yes","2026-03-01","30 days prior To Duke Energy complete","2026-10-01","2027-02-28",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-10-01"]
["Windstream",null,null,"Dayton Martin","2026-01-19","2026-02-01",16.100000000000001,"Approved",null,60,"Yes","2026-03-15","30 days prior To Spectrum complete","2027-02-01","2027-04-02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2027-02-01"]
["AT&T",null,null,"Dayton Martin","2026-01-21","2026-02-27",16.100000000000001,"In Progress",null,120,"Yes","2026-03-06","30 days prior To Windstream complete","2027-03-01","2027-06-29",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2027-03-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
["UBO- Underground",null,null,null,null,null,null,null,null,null," ",null,null,null,{"$f":"IF(N22=\"\",\"\",N22+J22)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
["Piedmont Nat. Gas",null,"PNG said Mid April to get package back to us. ","Dayton Martin","2026-02-17","2026-02-13",16.100000000000001,"In Progress",null,90,"Yes","2026-02-28",null,"2026-10-01","2026-12-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-10-01"]
["Segra in Ductbank",null,null,"Dayton Martin","2026-03-05","2026-02-02",16.100000000000001,"Approved",null,140,"Yes","2026-04-02",null,"2026-06-01","2026-10-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(N24), MONTH(N24), 1)","v":"2026-06-01"}]
["Spectrum in Ductbank",null,null,"Dayton Martin","2026-03-06","2026-03-03",16.100000000000001,"In Progress",null,140,"Yes","2026-03-27","30 days prior To Segra complete","2026-09-15","2027-02-02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-09-01"]
["Victory Comm. in DuctBank",null,null,"Dayton Martin","2026-02-14","2026-03-04",16.100000000000001,"Approved",null,140,"Yes","2026-03-17","30 days prior To Spectrum complete","2027-01-15","2027-06-04",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2027-01-01"]
["Lumen in Ductbank",null,null,"Dayton Martin","2026-02-08","2026-02-05",16.100000000000001,"In Progress",null,140,"Yes","2026-02-20",null,"2026-06-01","2026-10-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-06-01"]
["MCNC in Ductbank",null,null,"Dayton Martin","2026-02-01","2026-02-15",16.100000000000001,"In Progress",null,140,"Yes","2026-03-08",null,"2026-06-01","2026-10-19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-06-01"]
[null,null,null,null,null,null,null,null,null,null," ",null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
["UC",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
["Charlotte Water",null,null,"Ian Armstrong","2026-04-03",null,"UCA","In Progress",null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(N44), MONTH(N44), 1)","v":"1900-01-01"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]
["Backflow Preventer",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1900-01-01"]